| Key Name |
Key Type |
Keys |
| FaStudentAid_DateLoanStart_DateLoanEnd_N_N_IDX |
Inversion Entry |
LoanPeriodBeginDate, LoanPeriodEndDate |
| FaStudentAid_SyStudentID_AwardYear_FaFundSourceID_FaStudentAidID_U_N_IDX |
Alternate Key |
StudentId, AwardYear, FundSourceId, StudentAwardId |
| FaStudentAid_AwardYear_FaStudentAidID_U_N_IDX |
Alternate Key |
AwardYear, StudentAwardId |
| FaStudentAid_FaStudentAYID_N_N_IDX |
Inversion Entry |
StudentAcademicYearId |
| FaStudentAid_FaStudentAidID_U_C_IDX |
PrimaryKey |
StudentAwardId |
| Nk_FaStudentAidPromNoteCMDocumentID_CmDocumentCmDocumentId |
Inversion Entry |
PromNoteDocumentId |
| FaStudentAid_SaStudentBankAccountID_N_N_IDX |
Inversion Entry |
StudentBankAccountId |
| FaStudentAid_SaCcId_N_N_IDX |
Inversion Entry |
StudentCreditCardId |
| FaStudentAid_FaBatchPackageID_N_N_IDX |
Inversion Entry |
BatchPackagingProcessId |
| FaStudentAid_SyStudentID_IsAutoCredit_U_N_IDX |
Inversion Entry |
StudentId, IsAutoCredit |
| FaStudentAid_SyStudentID_IsAutoDraft_U_N_IDX |
Inversion Entry |
StudentId, IsAutoDraft |
| FaStudentAid_Source_N_N_IDX |
Inversion Entry |
Source |
| FaStudentAid_ServicerRecordID_N_N_IDX |
Inversion Entry |
ServicerRecordIdentifier |
| FaStudentAid_FaStudentPellID_N_N_IDX |
Inversion Entry |
StudentAwardPellId |
| FaStudentAid_FaFundSourceID_N_N_IDX |
Inversion Entry |
FundSourceId |
| NK_FaStudentAid_AwardYear_INCL |
Inversion Entry |
AwardYear |
| FaStudentAid_FaCODGrantID_FaStudentAidID_U_N_IDX |
Alternate Key |
CodGrantOriginationId, StudentAwardId |
| FaStudentAid_FaFundSourceID_FaBankID_Source_N_N_IDX |
Inversion Entry |
StudentAwardId, FaLenderId, Source |
| Nk_FaStudentAid_Id_AdEnrollId_StudentAYId_FundSourceId_AwardYear |
Inversion Entry |
StudentAwardId, StudentAcademicYearId, FundSourceId, AwardYear |
| Uk_FaStudentAid_FaFundSourceID_AwardYear_Status_AdEnrollID_FaStudentPellID_SyStudentID_FaStudentAidID |
Alternate Key |
FundSourceId, AwardYear, Status, StudentAwardPellId, StudentId, StudentAwardId |
| FaStudentAid_AdEnrollID_Source_FaFundSourceID_AwardYear_Status_N_N_IDX |
Inversion Entry |
Source, FundSourceId, AwardYear, Status |
| FaStudentAid_Status_FaFundSourceID_AwardYear_FaBankID_AdEnrollID_FaStudentAidID_SyStudentID_N_N_IDX |
Inversion Entry |
Status, FundSourceId, AwardYear, FaLenderId, StudentAwardId, StudentId |
| Nk_FaStudentAid_Id_AdEnrollId_FundSourceId_AwardYear_BankId_LoanDates |
Inversion Entry |
StudentAwardId, FundSourceId, AwardYear, FaLenderId, GuarantorLendingInstitutionId, LoanPeriodBeginDate, LoanPeriodEndDate |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| LendingInstitution |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
FaLenderId |
NO |
| BatchPackagingProcess |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BatchPackagingProcessId |
NO |
| CodGrantOrigination |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CodGrantOriginationId |
NO |
| FundSource |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
FundSourceId |
NO |
| StudentAwardPell |
Identifying |
One To Zero or More |
|
|
|
StudentAwardId |
NO |
| StudentAcademicYear |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentAcademicYearId |
NO |
| StudentCreditCard |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentCreditCardId |
NO |
| StudentBankAccount |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentBankAccountId |
NO |
| Student |
Non-Identifying |
One To Zero or More |
|
|
|
StudentId |
NO |
| Student |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentId |
NO |
| StudentCreditCard |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentCreditCardId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| StudentRelationshipAddress |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentRelationshipAddressId |
NO |